有关"order by" 用法

来源：百度知道 编辑：UC知道 时间：2024/06/03 17:19:58
请问如果我想在下面加上 ' order by title asc' ， 应该加在哪里才能使最后结果以字母顺序表示出来？ 谢谢

select Film.title
from Film,Film_Actor ,Actor
where Film.film_id = Film_Actor.film_id and
Film_Actor.actor_id = Actor.actor_id and
Actor.first_name ='q' and Actor.last_name= 'a'
minus
select Film.title
from Film,Film_Actor ,Actor
where Film.film_id = Film_Actor.film_id and
Film_Actor.actor_id = Actor.actor_id and
Actor.first_name ='P' and Actor.last_name= 'o'

select a.* from
(select Film.title
from Film,Film_Actor ,Actor
where Film.film_id = Film_Actor.film_id and
Film_Actor.actor_id = Actor.actor_id and
Actor.first_name ='q' and Actor.last_name= 'a'
minus
select Film.title
from Film,Film_Actor ,Actor
where Film.film_id = Film_Actor.film_id and
Film_Actor.actor_id = Actor.actor_id and
Actor.first_name ='P' and Actor.last_name= 'o') a
order by a.title asc

加在最外层吧，外层再套个select:
select B.title from
(
select Film.title
from Film,Film_Actor ,Actor
where Film.film_id = Film_Actor.film_id and
Film_Actor.actor_id = Actor.actor_id and
Actor.first_name ='q' and Actor.last_name= 'a'
minus
select Film.title
from Film,Film_Actor ,Actor
where Film.film_id = Film_Actor.film_id and
Film_Actor.actor_id = Actor.actor_id and
Actor.first_name ='P' and Ac